Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
MCSE 2000 Elective: SQL Server 2000 Administration
with Wayne Snyder


View Course Outline

With the SQL Server 2000 Administration training course from network administrators will learn techniques for installing, configuring, and administering SQL Server 2000. Expert instructor Wayne Snyder's friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you'll be prepared for successful system administration and be ready to pass exam #70-228, which provides core credit toward MCDBA certification and elective credit toward MCSE certification upon successful completion.

Entire course includes 12+ hours of total training time...

  • 7 CDs
  • Over 12 hours of media run time
Format Sessions Price
70-228 Course
CD-ROM

 7 CD-ROMs

$555.00  
Read about Wayne Snyder.
Course Outline (Outlines are subject to change.)

Installing, Configuring, and Administering
SQL Server 2000 Enterprise Edition

Sessions Run Time
7 CDs 12 hours

With the SQL Server 2000 Administration training course from network administrators will learn techniques for installing, configuring, and administering SQL Server 2000. Expert instructor Wayne Snyder's friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you'll be prepared for successful system administration and be ready to pass exam #70-228, which provides core credit toward MCDBA certification and elective credit toward MCSE certification upon successful completion.

 

SESSION 1
Total Time: 110 Minutes

Section A: Introduction

  • SQL Server Goal
  • SQL Platforms
  • SQL Server

Section B: Installation Options

  • System Requirements
  • Architecture Enhancement
  • Server Editions
  • Multiple Instances
  • Installation Options
  • File Locations
  • Collation
  • Sort Order
  • Domain Login
  • Network Protocol
  • Unattended Setup

Section C: Installation

  • Basic Install
  • Post Installation
  • Register Server
  • Check/Verify Logins
  • Network Libraries
  • Startup Option
  • Start/Stop Services
  • Verify Directories

Section D: Troubleshooting Installations

  • Basic Steps
  • Common Install Failures
  • SQL Agent Issues
  • Client Issues
  • Named Pipes
  • TCP/IP

Section E: Upgrade from 6.5

  • Requirements
  • One/Two Computer Upgrade
  • Consolidation
  • Data Transfer Method
  • Upgrade Checklist
  • Upgrade Wizard

Section F: Upgrade Methods

  • Overview
  • Hardware/Software Requirements
  • Installation Upgrade
  • Post Upgrade
  • Warning
  • Online Database Upgrade
  • Online Upgrade Exceptions
  • Upgrade & Replication
  • Online Database Upgrade
  • Installation Upgrade

Section G: Server Security

  • Basic Steps
  • Logon Methods
  • Authentication Mode
  • SQL Login Commands
  • Group Usage
  • Add NT User
  • Connect Using NT
  • Add SQL User
  • Add NT Group
  • Validate Login
  • Deny Access

SESSION 2
Total Time: 110 Minutes

Section A: Database Security

  • Adding Users
  • New User & Login
  • Special Users
  • Disable Guest
  • Database User Command

Section B: Database Permissions

  • Overview
  • Object Permission
  • Permission Rules
  • Object References
  • Chain of Ownership
  • Chain Issues
  • Dbo Ownership
  • Roles
  • Server Fixed Roles
  • Database Fixed Roles
  • Create a Role
  • Permissions Accumulate
  • Application Role
  • Use of Application Roles
  • Creating a Role

Section C: Creating Databases

  • Databases in SQL Server
  • Master/Model
  • Temp db/MSdb/Distribution
  • Database Objects
  • File Types/Pages
  • Transaction Log
  • Create Database Options
  • Syntax
  • Recovery Considerations
  • Create a Database

Section D: Placing Database Files

  • Storage Management
  • RAID Options
  • RAID 1
  • RAID 0 on RAID 1
  • RAID 5
  • Filegroups
  • Files in Filegroup
  • Create Filegroups
  • Using Filegroups
  • Filegroups & Maintenance
  • Performance Considerations

Section E: Altering a Database

  • Using Alter Database
  • Changing Database Options
  • Setting Options
  • Shrink Databases
  • Examining Databases
  • Space Estimation
  • Rules of Thumb for Logs

SESSION 3
Total Time: 105 Minutes

Section A: Constraints

  • Default Constraint
  • Create Default Constraint
  • Check Constraint
  • Check Constraint Abilities
  • Using Check Constraints
  • Add Records Using Check Constraints
  • Table Level Constraints
  • Primary Key Constraints
  • Create Primary Key Constraints
  • Multiple Column Primary Key
  • Unique Constraints

Section B: Foreign Key Constraints

  • Planning Foreign Keys
  • Foreign Keys & Table Actions
  • Rules for Foreign Keys
  • Create Foreign Keys
  • Using Foreign Keys
  • Create Table Level Constraint
  • Altering Tables
  • Disabling Constraints

Section C: Indexes

  • Overview
  • Indexes & Data Storage/Access
  • Clustered Index
  • Planning Clustered Index
  • Non-Clustered Index
  • Non-Clustered with Clustered

Section D: Index Maintenance

  • Creating Indexes
  • Empty Pages
  • Full Pages
  • Fill Factor
  • Drop an Index
  • Tips for Using Indexes
  • Using Indexes

Section E: Stored Procedures

  • Overview
  • Planning Stored Procedures
  • Create/Execute
  • Using Stored Procedures

SESSION 4
Total Time: 103 Minutes

Section A: Triggers

  • Overview
  • Planning Use of Triggers
  • After Trigger
  • Inserted/Deleted Table
  • Create Triggers
  • Using Triggers
  • After vs. Instead of

Section B: Views

  • Overview
  • Planning Use of Views
  • Details of Views
  • Customize View
  • Insert in Views
  • Indexed View
  • Set Stats/Execution Plan
  • Partitioned Views

Section C: Database Backup

  • Why Backups?
  • Backup Models
  • Full Recovery
  • Bulk-Logged Recovery
  • Simple Recovery
  • Permissions Required
  • Backup Methods
  • Backup Timing
  • Full Backup
  • Using Dump Device
  • Backup Options
  • Tape Option
  • Create Backup
  • Enterprise Manager
  • Differential Backup

Section D: Backup Transaction Logs

  • Why Backup Logs?
  • Normal Log Backup
  • Truncate Only/No Log
  • Log Full
  • Long Transactions
  • View from Enterprise Manager
  • Backup No Truncate
  • Standard Scenario

Section E: Filegroup/Optimize Backups

  • Overview
  • Filegrouping
  • Large Database Backup
  • Filegroup Scenario
  • Optimizing Backups
  • Stripped Backup
  • Backup Performance

SESSION 5
Total Time: 116 Minutes

Section A: Restore & Recovery

  • Automatic Recovery
  • Transaction Log with Recovery
  • Restore Process
  • Check Media
  • Restore Steps
  • Restore Options
  • Restoring Log
  • Restoring Master
  • Restore Scenario
  • Restore Database
  • Restore Logs
  • Basic Restore Commands

Section B: High Availability Solutions

  • Overview
  • Standby Server
  • Log Shipping
  • Starting SQL Agent
  • Setup Log Shipping
  • Setup Backup Criteria
  • Troubleshooting Log Shipping
  • Log Ship Role Change
  • User/Login Mapping
  • Cluster Server
  • Windows Clustering
  • SQL Clustering
  • Active/Passive Cluster
  • Active/Active Cluster
  • Log vs. Cluster

Section C: Relocating Data

  • Overview
  • Attach/Detach Database
  • DTS
  • Create DTS Package
  • DTS Tasks/Steps
  • Transform Data
  • Data Lineage
  • Use DTA Wizard
  • DTS Designer
  • Verify Metadata
  • DTS Workflow
  • Change Data Type
  • Export/Import DTS
  • Import File
  • Bulk Insert/BCP

Section D: Replication Overview

  • Why Replication
  • Replication vs. DTS
  • Roles & Language
  • Publications/Articles
  • Publisher/Subscriber
  • Remote Distribution

SESSION 6
Total Time: 100 Minutes

Section A: Types of Replication

  • Overview
  • Snapshot
  • Transactional
  • Merge
  • Updating Subscribers
  • New Replication Features

Section B: Implementing Replication

  • Planning
  • Designing
  • Distributor Setup
  • Configuring a Distributor
  • Publisher Setup
  • Configuring a Publisher
  • Create Publication
  • Push Subscription
  • Replication Monitor
  • Alerts
  • Updating Subscribers
  • Troubleshooting Replication
  • Internet/Heterogeneous Replication

Section C: Linked Servers

  • Distributed Query
  • Setting Up a Linked Server
  • Linked Server Options
  • Troubleshooting Linked Servers
  • Changing Data
  • Create Linked Server
  • Link to Excel Spreadsheet

Section D: Server Automation

  • Overview
  • Setup Mail Integration
  • Test Mail Integration
  • Create Operator
  • Create Jobs
  • Advanced Options/Create Steps
  • Notifications
  • Using Jobs

SESSION 7
Total Time: 112 Minutes

Section A: Managing Automation

  • Alerts
  • Using Raise Error
  • Error Log/NT Event Log
  • XP-Log Events
  • Create Alerts
  • Respond to Alerts
  • Multiple Operator Notification
  • Performance Monitor Alert
  • Failsafe Operator/Master Server Wizard
  • Alert Response Delay
  • Automation Troubleshooting

Section B: SQL Mail Integration

  • SQL Mail Setup
  • Using SQL Mail
  • Triggers
  • Mail Troubleshooting

Section C: Monitoring SQL Server

  • Overview
  • Memory Monitoring
  • Processor Monitoring
  • Disk I/O Monitoring
  • System Monitor
  • SQL Server Monitoring
  • Optimize Processor Use
  • Monitoring Locks
  • SP_WHO Command
  • Locks in Enterprise Manager
  • Deadlock (1205) Error
  • Profiler
  • Using Profiler
  • Server Configuration
  • DBCC

Section D: Optimizing Database Performance

  • External Fragmentation
  • Data Fragmentation
  • Index Statistics
  • Using Indexes
  • Query Statistics
  • Execution Plans
  • Optimize Queries
  • Re-Compiling Stored Procedures

Section E: IIS Virtual Directory

  • Creating the Virtual Directory
  • Configure XML Support
  • Using Internet Explorer with SQL
  • Section F: Security Auditing
  • Methods
  • C2 Auditing
  • C2 vs. SQL Profiler
  • Additional Resources

back to top


Your Instructor

Wayne Snyder is a recognized expert in application development and database design and modeling with specialization in Microsoft SQL Server. Wayne has worked with SQL from its first release, and won the prized Microsoft MVP (Most Valuable Professional) award in 1998. His certifications include MCDBA, MCSE, and MCT. Wayne is a highly respected speaker at industry conferences and a sought-after reviewer for major technical publications. He is a popular instructor and consultant currently working with IKON Education Services.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy